Think it a JOIN problem?!

[ChrisMacPherson]

Hello all,

I have two tables, as below

msgTable userTable
======== =========
msgId userId userId userName
--------------- --------------------
0 4 4 'Foo'
1 4 5 'Bar'
2 5 6 'BarBar'

Right, I want to select certain msgs from my msgTable AND the associated userName from the userTable all in one go.
I think this should be possible, but cant quite work it out from the docs.

Thanks for any help! Chris MacPherson

 

[nigelcohen]

Try this:

select msgTable.msgID, userTable.userID
from msgTable, userTable
where userTable.userID = msgTable.userID
order by msgTable.userID

There are many variants (eg. select * from ... when you want to select everything) and simplifications (eg. select.m.msgID .... from msgID m ....)