How to fetch dates from two different tables?

Question

1.00/5 (2 votes)

See more:

I have two different tables both having a common field i.e, Marriage Anniversary date and obviously of 'date' type. One is having details of husband and another having details of wife.
Is there any way, so that the upcoming Anniversaries may be fetched from both tables at same time or in same GridView(in Asp.Net)...
Or some other ways whatever I can do in this....

Posted 3-Dec-15 1:58am

Member 12133159

Add a Solution

Comments

xszaboj 3-Dec-15 8:04am

can you give more specific example of your table? and what you want? I might be able to help

Member 12133159 4-Dec-15 0:04am

I'm having two tables having information of Marriage Anniversary Dates and other data of some couples. Now I have to fetch upcoming Anniversaries from both tables simultaneously so that I can display the name of couples with their Date of Marriage Anniversaries...

Suvendu Shekhar Giri 3-Dec-15 8:09am

Just use JOIN
http://www.w3schools.com/sql/sql_join.asp[^]

And if you find issue while writing this query, come up with the problematic query so that we can help :)

CPallini 3-Dec-15 8:23am

My (virtua) 5.

Suvendu Shekhar Giri 3-Dec-15 9:13am

Thanks :)

ZurdoDev 3-Dec-15 8:14am

Yes, use a join. Very simple to do.

1 solution

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)

FrancoisViljoen · Accepted Answer · 2015-12-03T07:17:00

Solution 1

The issue here might be related to the fact that both tables has the same field names.

So you could use aliasing, something like:

C#

SELECT
  TableA.AnniversaryDate as 'TableADate',
  TableB.AnniversaryDate as 'TableBDate',
FROM
  TableA join TableB on (TableA.Key = TableB.Key)

Posted 3-Dec-15 7:17am

FrancoisViljoen

Comments

Maciej Los 3-Dec-15 16:16pm

Looks like MS Access database query statement...