Advertisement
Guest User

Untitled

a guest
Jan 20th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. SELECT DISTINCT
  2.   p.id AS Identyfikator,
  3.   p.first_name AS Imię,
  4.   p.last_name  AS Nazwisko,
  5.   c.name       AS [Nazwa nieopłaconej konferencji]
  6. FROM dbo.Participant AS p
  7.   LEFT JOIN  dbo.BookingDayReservationParticipant AS b ON p.id = b.participant_id
  8.   INNER JOIN  dbo.BookingDay AS bd ON bd.conference_day_id = b.id
  9.   INNER JOIN  dbo.ConferenceDay AS cd ON cd.id = bd.conference_day_id
  10.   INNER JOIN  dbo.Conference AS c ON c.id = cd.conference_id
  11. WHERE (b.paid_date IS NULL)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement