How Can I Join These Two Tables?

Question

1.00/5 (1 vote)

See more:

I have two tables(namely tblperson and tbljob) and also I have a gridview. I want to display in my gridview all the records from tblperson and one field in tbljob. They do not have any key to form...

I am a beginner in ASP.Net. This is the scenario I am facing today in creating this project. Please someone help me. Thanks :)

Posted 9-Jul-14 16:58pm

DarkDreamer08

Updated 9-Jul-14 17:36pm

Prasad Avunoori

v2

Add a Solution

Comments

DamithSL 9-Jul-14 23:00pm

don't put everything in question title, explain in the body of the question

ArunRajendra 9-Jul-14 23:03pm

I guess you don't have a relation between the two table if so its not possible. You need to have relation between the two tables.

DamithSL 9-Jul-14 23:17pm

what is your database and the version?

DarkDreamer08 9-Jul-14 23:29pm

I am sorry about that. It's just my second time to post question here.

SQL SERVER 2008 R2

Prasad Avunoori 9-Jul-14 23:37pm

Can you please post your two tables column names and expected result set?

DarkDreamer08 10-Jul-14 0:34am

I would like to show it to you but i do not know how to paste the picture here :) I am sorry about that.

Manoj Kumar Choubey 9-Jul-14 23:49pm

You don't have relation between table ? , Please show the relevant example data and column name of the table in your question then we can suggest you.
without relation key is not possible to join tables

Prasad Avunoori 9-Jul-14 23:52pm

If there is no relation, there is no use of joining.

[no name] 10-Jul-14 0:37am

if there is no relation ,the joins will be not possible but you can use the union or union all to show the records from 2 diff table, but it will display in row by row....

DarkDreamer08 10-Jul-14 0:39am

It could be! Thanks for your suggestion. How can I mark it as a solution?

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sarvesh Kumar Gupta · Accepted Answer · 2014-07-09T18:42:00

Solution 2

Hi,

Use below Query

SQL

Select tblPerson.*, tblJob.Field1 from tblPerson, tblJob where -- Use condition, if you want.

It is Cross join without relation, use this and if you have any confusion then you can ask me.

Posted 9-Jul-14 18:42pm

Sarvesh Kumar Gupta

Hrushikesh_phapale · Accepted Answer · 2014-07-09T18:41:00

Solution 1

if there is no relation ,the joins will be not possible but you can use the union or union all to show the records from 2 diff table, but it will display in row by row....

Posted 9-Jul-14 18:41pm

Hrushikesh_phapale

How Can I Join These Two Tables?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

How Can I Join These Two Tables?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us