[SOLVED] Woz Wrong in this Inner Join... Urgent Plz....!!!!!!

[ashii]

SELECT user.firstname, user.lastname, user.contact,user.address, user.email, vehicle_dtls.Vid,vehicle_dtls.name, vehicle_dtls.model, vehicle_dtls.seats
FROM (user INNER JOIN vehicle_dtls ON user.ID = vehicle_dtls.ID)(vehicle_dtls INNER JOIN tbl_busimage ON vehicle_dtls.Vid= tbl_busimage.Vid)
WHERE vehicle_dtls . route = 'USA-NEWYORK'

[aschk]

What's the error message?

What data do you have?

What data are you expecting?

What is your schema layout?

 

And as a prelude to you answering the questions above i've written out your query to be more readable (and it would appear i have also corrected your problem...)

 

SELECT u.firstname
      ,u.lastname
      ,u.contact
      ,u.address
      ,u.email
      ,v.Vid
      ,v.name
      ,v.model
      ,v.seats
FROM user u
INNER JOIN vehicle_dtls v ON u.ID = v.ID
INNER JOIN tbl_busimage b ON v.Vid= b.Vid
WHERE v.route = 'USA-NEWYORK'

[ashii]

Thank u vry mch.. i fixed it sum hw... since I waz vry Hurry to execute dis query. i dint post the needed info abuh da schema..