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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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