Re^7: sql join with multiple select

In your original post the MSG table with added fields was

msg_id    msg_from     msg_to      received  title    age     country

but now your sql select includes city twice. What columns are you trying to add. ?

SELECT SND.userid, SND.fname, SND.lname, SND.city, SND.age, SND.city

poj

Comment on Re^7: sql join with multiple select

Replies are listed 'Best First'.
Re^8: sql join with multiple select by bigup401 (Pilgrim) on Oct 04, 2018 at 17:08 UTC
sorry i mixed city with country and also forget to include title but this is the MSG Table and thats wat i want to select `SELECT SND.userid, SND.fname, SND.lname, SND.title, SND.age, SND.count +ry` [download]	[reply] [d/l]
Re^9: sql join with multiple select by poj (Abbot) on Oct 05, 2018 at 14:36 UTC
It looks like the table alias names SND and M are confusing you so remove them. If this is now your tables `TABLE users userid firstname lastname 1 JOHN DEO 2 JANE DEO TABLE msg msg_id msg_from msg_to received age city country` [download] The correct SQL (without alias names) is `SELECT users.userid, users.firstname, users.lastname, msg.age, msg.cit +y, msg.country FROM msg JOIN users ON users.userid = msg.msg_from WHERE msg.msg_to = ? AND msg.received IS NULL` [download] poj	[reply] [d/l] [select]
Re^10: sql join with multiple select by bigup401 (Pilgrim) on Oct 05, 2018 at 14:48 UTC
thanks poj. i was already fixed my query	[reply]