Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

make a join between two data tables and get one result table

Home
Forums
.NET

make a join between two data tables and get one result table

Koteswararao Mallisetti

16yAsked Jul 23, 2010, 2:27 AM2.7k.NET

hai

i have a 2 table withe name are Foxtable , AccessTabel in this comman column is primkey and,FkprimKey based on this command column i want retrive one table that table is given to grid how can i get the result table

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Koteswararao Mallisetti16y ago
dierectly i write that select statement i get an error under the select keyword

vishal jadav16y ago

hi buddy,

u can try like

select table1.fieldname1,table1.fieldname2,table2.fieldname1 ......... from table1 , table2 where table1.primarykeyfield = table2.foreignkeyfield

that's it...

another complex way is also available like "join" , inner join, outer join etc. but above is easiest.....