Advertisement
Guest User

Untitled

a guest
Feb 10th, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. Error code: 1222 the used SELECT statements has a different number of columns
  2.  
  3. SELECT PsngrInit,PsngrLNam,SeatId,TourId
  4. FROM passenger
  5. INNER JOIN booking
  6. ON passenger.PsngrId=booking.PsngrId
  7. WHERE booking.PortionId='Melb-Geel'
  8. UNION
  9. SELECT SeatTypId
  10. FROM seattype
  11. INNER JOIN booking
  12. ON booking.SeatId = seattype.SeatId
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement