relationships in mysql

[ohitsme]

hi,

i know when ive used ms access, i could set it up so i could do something like (i have forgotten the syntax of mssql so this is mysql language)

 

select table1.title,table2.amount from table1 where table1.id=123

 

(ie, set it up so it knows what the primary and foreign keys are, and not require any join statements or where table1.id = table2.prodid)

 

is there any way to set up things like this in mysql?

 

thanks

[trq]

Take a look here.

[xtopolis]

I think you can do:

SELECT table1.title, table2.amount from table1, table2 WHERE table1.id=123

but you'd probably need a WHERE modifier for table2 as well..

 

I don't know.. I don't do it that way.. is there a reason you're avoiding joins?