taking values from fields

Posted by jagadeesh on Stack Overflow See other posts from Stack Overflow or by jagadeesh
Published on 2010-03-08T11:57:41Z Indexed on 2010/03/08 12:06 UTC
Read the original article Hit count: 383

Filed under:

there is two table first table is pg_vendor_signup

pg_vendor_signup id vendor_id name country_id

secound table is pg_vendor_friends vid fid status

pg_vendor_signup contain data is

1 3 ramu 381

2 4 raj 381 2 4 usha 381 3 4 krian 381 4 4 manu 381

4 9 aswin 381

pg_vendor_friends countain 1 9 4 0

1 9 3 0

i Want get all name where country id=381 and in pg_vendor_friends get status of table

© Stack Overflow or respective owner

Related posts about mysql-query