i have a table with user name,user password,full name
and another table with buy_id,user name
know when i print to the screen the row with the buy_id
i donnt want to print the user name but his full name (which is on the other table!
how do i do that?
thanks in advance
peleg
select help needed
Moderator: General Moderators
As mentioned, you need a table join. But first you could maybe improve your db design a little by adding auto-incrementing integer ids. It's good practice to have a "meaningless" id for every row ie don't use an invoice number, NI number etc which, as well as being a row identifier, has additional meaning.
All, including JOINs, explained here http://www.oreilly.com/catalog/javadtab ... r/ch02.pdf
All, including JOINs, explained here http://www.oreilly.com/catalog/javadtab ... r/ch02.pdf