Topic: 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

[thorpe]

Take a look here.

[xtopolis]

I think you can do:

Code: [Select]

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?