fetch data frm multiple tables
-
I want to fetch data from three tables according to itemcode .and item code is entering only two tables. plz help me
What is with the run of stupid questions ? First of all, this has nothing to do with ASP.NET, you should be asking in the SQL forum Second, you can't possibly expect or want help. If you did, you'd ask a question that could be answered. We can't work out what you need to do, without knowing the schema of the tables. Third, if there's no other ID you can use to link these tables, then it's probably not possible, and you need to talk to whoever designed the database and get them to fix it. You should not attempt it yourself, because it seems you don't really know anything about databases.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
I want to fetch data from three tables according to itemcode .and item code is entering only two tables. plz help me
rummer wrote:
I want to fetch data from three tables according to itemcode .and item code is entering only two tables.
How this is related with ASP.NET ? You need to write simple SQL query with join operation.
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.
-
I want to fetch data from three tables according to itemcode .and item code is entering only two tables. plz help me
How is this possible? :omg: Can you show ur table structure. You should have posted this in Database forum.
-
I want to fetch data from three tables according to itemcode .and item code is entering only two tables. plz help me
Then the third table must contain any key column from other two tables or somehow it should be connected to other two tables. Provide the table schemas to get more help.
-
I want to fetch data from three tables according to itemcode .and item code is entering only two tables. plz help me
You can use a Join
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
You can use a Join
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
Oh, seriously. One stupid question, and it needs 6 answers, all increasingly clueless ? What does this add to the discussion ? He plainly has no idea what a join is, and the issue is, there's no indication that he has anything to join to, in the third table. I expect that's why he's asking the question, even if he does ask it so inadequately.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
Oh, seriously. One stupid question, and it needs 6 answers, all increasingly clueless ? What does this add to the discussion ? He plainly has no idea what a join is, and the issue is, there's no indication that he has anything to join to, in the third table. I expect that's why he's asking the question, even if he does ask it so inadequately.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
It is very much frustrating when people don't reply when some one wants to help him :( . It may happen after some time he will delete his post :laugh: . These are useless !! :(
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.