SQL DATAGRID HELP - Sajha Mobile
SAJHA MOBILE
SQL DATAGRID HELP
Posts 3 · Viewed 5568 · Go to Last Post
stolen_thoughts
· Snapshot
Like · Likedby · 0
how can i merge values from two different tables in a single data grid?

For E.g I have
tbl1
contry{cid, name},

and tbl2
country_deatil{cid, location, address}

I need to print {cid, name, location, address} in a single data grid.

Please HELP ME OUT.
JayNir
· Snapshot
Like · Liked by · 0

 

Last edited: 15-Jan-09 08:45 AM
Pretty
· Snapshot
Like · Liked by · 0

Just do


select * from contry a, country_detail b where a.cid=b.cid

Please log in to reply to this post

You can also log in using your Facebook
View in Desktop
What people are reading
You might like these other discussions...
· Posts 77 · Viewed 18467 · Likes 16
· Posts 1 · Viewed 107
· Posts 1 · Viewed 115
· Posts 1 · Viewed 299
· Posts 16 · Viewed 3556 · Likes 3
· Posts 1 · Viewed 229
· Posts 1 · Viewed 348
· Posts 6 · Viewed 941 · Likes 1
· Posts 1 · Viewed 179
· Posts 1 · Viewed 186



Your Banner Here
Travel Partners
Travel House Nepal