[Show all top banners]

stolen_thoughts
Replies to this thread:

More by stolen_thoughts
What people are reading
Subscribers
Subscribers
[Total Subscribers 1]

khanalashish
:: Subscribe
Back to: Computer/IT Refresh page to view new replies
 SQL DATAGRID HELP
[VIEWED 3191 TIMES]
SAVE! for ease of future access.
Posted on 01-06-09 12:50 AM     Reply [Subscribe]
Login in to Rate this Post:     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.

 
Posted on 01-15-09 8:30 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?        
 

 

Last edited: 15-Jan-09 08:45 AM

 
Posted on 01-15-09 8:35 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?        
 

Just do


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


 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 30 days
Recommended Popular Threads Controvertial Threads
What stocks to buy -- Any recommendation
TRUMP 2016!!! Here is why?
ट्रंप २०२०
❤️ चिक्नी चमेली ❤️
Fox News: Wear the Damn Mask, it is not political issue but a public health issue.
About some Nep Trumpers
Why people voted for Trump?
Photo of the day
कोभिड लाग्यो!
त्रुम्प्ले आफैले आफुलाई क्षमादान गर्ने भो, It may be the first and last Self-Pardon.
Cheater-in-chief
स्कूलमा पढेका कथा - भुतको शिकार, शिशिर बसन्तको कथा देखि टाउकोको मोल सम्म
Love trumps Hate
Sajha Poll: I Voted
Is Trump trying to overturn an election?
Someone killed drona!!
राजशी दशैं .. भोकाएकाको दशैं ..
Corona virus - how deadly is it really? and for whom?
आहा! कती मिठो गीत्!
लगातार २ छोरि हुदाको पिडा
TRUMP 2016!!! Here is why?
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters