comparing two value of money field

Question

0.00/5 (No votes)

See more:

I want to compare two field of two separate table !
for example tbl_User (UserId, amount) and tbl_Product(UserId,ProductId, Pamount) ...
and for example comparing fields: amount and Pamount
is there a need to have a relation in this two table ??
please help me ...

Posted 6-Feb-12 7:32am

EhsanGhanbari

Add a Solution

Comments

Amir Mahfoozi 7-Feb-12 1:45am

What have you done so far? Please provide your SQL statement.

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)

OriginalGriff · Answer 1 · 2012-02-06T08:09:00

Solution 1

No.
For example there is no formal relationship between these two tables:

SQL

SELECT S.[StudentId], S.Name, M.Amount , M.MissionID
  FROM [Testing].[dbo].[Student] AS S, [Testing].[dbo].[myTable] AS M
  WHERE S.StudentId=M.MissionID

Posted 6-Feb-12 8:09am

OriginalGriff

Comments

EhsanGhanbari 6-Feb-12 14:23pm

is it possible to compare two field of table that are in same data type ??
I wanna to compare two amount of money that area stored in two joined separate table ?? please help me about that ...

OriginalGriff 6-Feb-12 14:44pm

The query I showed you does just that, but with integers - there is no join, no formal relationship needed. As long as the two fields are the same datatype, the comparison is valid.
Doesn't mean it will be efficient! :laugh:

**AmitGajjar** · Answer 2 · 2012-02-06T19:20:00

Hi,

it's all depends upon what you would like to compare ? suppose you would like to find out sum of (Pamount+amount) for every user in that case you need aggregate function and joining between UserId of the both the field.(this is just an example)

Conclusion : you do not need joining only if tbl_Product.Pamount and tbl_User.amount is independent on UserId.

hope this information will help you,

thanks
-Amit.