select help needed

pelegk2 · #1 (**permalink**) 01-28-04, 08:40

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

r937 · #2 (**permalink**) 01-28-04, 08:57

Code:

select buy_id, fullname
  from anothertable
inner
  join atable
    on anothertable.username = atable.username
 where buy_id = 937

pelegk2 · #3 (**permalink**) 01-28-04, 09:14

Internet Services

Web Development

Digital Marketing

Consumer Tech