I have to generate report containing data from these two tables and there is no field matching ?

Question

0.00/5 (No votes)

See more:

I have two tables DataCard_Master with fields

DataCard_Name

DataCard_No (PK)

Model

Reporting Manager

IssuedOn

and another table is Team_master with fields

ID (PK)

Team Name (Its a DropDown containing values, so i made it as separate table )

I have to generate the report with all the five fields of Datacard_Master and (Team Name) of Team_Master which i select from drop down for respective DataCard_No .

Posted 24-Sep-13 6:21am

Ankit Mishra

Add a Solution

Comments

Mehdi Gholam 24-Sep-13 12:23pm

... and you expect us to help you how?

Ankit Mishra 24-Sep-13 12:30pm

Sir I am new SQL server i am trying but i am getting all the values from Team_master for single field for DataCard_master.

Mehdi Gholam 24-Sep-13 12:35pm

First contact your db admin and ask him/her how to relate those two tables.

mgoad99 24-Sep-13 12:37pm

Isn't DataCard_No the related field that is in each table?

Love 2 code 24-Sep-13 12:46pm

I suggest adding a column team_master_id to the table DataCard_Master and fill that column with the chosen id from Team_master. There you have your connection.
Peace!

2 solutions

Solution 1

Basically, you have to think of this from a logical point of view: What connects the two tables?
Think of it this way: you can have a shopping list that contains all the items you need to buy for supper tonight, and a ToDo list that contains all the tasks you need to complete - including going shopping and cooking the supper - but unless each row in the ToDo list is related to a single item in the shopping list, they are not related, so you can't get "A ToDo with it's shopping item".

You have two tables, and the only vague connection I can see is that the ReportingManager could be a TeamMaster in which case you can indeed select the date how you want:

SQL

SELECT d.DataCard_Name, d.DataCard_No, d.Model, t.TeamName, d.IssuedOn FROM DataCard_Master d
JOIN Team_master t ON t.ID=d.ReportingManager

If that isn't a valid connection, then you need to establish such a connection first - or you can't logically retrieve any related data.

Posted 24-Sep-13 8:33am

OriginalGriff

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)

seyed mahmud shahrokni · Accepted Answer · 2013-09-24T08:44:00

Solution 2

in The concepts of database
When we have tables with no common attributes ,
we have to use Cross join .
in Cross join Each Row See all other rows
So you have a chance to compare all the rows together

Posted 24-Sep-13 8:44am

seyed mahmud shahrokni