Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2010-04-06 : 16:40:35
|
| Hi,I have two tables such as ticket and customer,in customer table i have these fields such mobileno,customerName,Addrss,Id etc....ID column is autogenerated(IDENTITY)In, ticket table,I have these fields,id,cust_id,ticket_detail,createdDate etc....here also ID is autogenerated,Now, there can be more than one ticket for one customerI need query like,display all tickets with customer mobileno and customernamemeans like thismobileno,customername,ticket_detail,createdDate etc.....Regards,ASIF |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
i need query or SP for this