SELECT * FROM table1, table2 WHERE table1.user_id = table2.user_id



"John E. Haag" wrote:

> Hi,
>
> Can anyone tell me how to properly execute a JOIN from PHP to
> MySQL??
>
> I just want to JOIN two tables, both of which have 'user_id' in
> common, and then get all of the fields from the matching records.
>
> Can anyone tell me where to find some info on this or cut-n'-paste
> a little helpful code?
>
> Thanks a lot to everyone.
>
>   -  John Haag
>
>             O N E  P O W E R F U L  C L I C K
>        All4one Search Machine http://www.all4one.com
> All4one Submission Machine http://www.all4one.com/all4submit
>                       (614) 575-9897
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to