need help with some Simple queries :(

suhas_sm · #1 (**permalink**) 07-16-10, 03:35

1. I have two tables Invoice and Payment. Pay_no is foreign key in Invoice table. Now I want to make a view that say whether payment is made or not.

how can it be done ?

Thank you. Need help desperately

Wise_Eye · #2 (**permalink**) 07-16-10, 14:01

Please list out the names and data types of each of the columns in both tables.

LKBrwn_DBA · #3 (**permalink**) 07-16-10, 14:51

Quote:

Originally Posted by suhas_sm

1. I have two tables Invoice and Payment. Pay_no is foreign key in Invoice table. Now I want to make a view that say whether payment is made or not.

how can it be done ?

Thank you. Need help desperately

Maybe you need to start studying your SQL 101 course and not ask for someone to do your homework.

waris_ariana · #4 (**permalink**) 07-21-10, 02:51

Please list the Columns + datatypes of both tables individually to resolve.

Ashique Raheem · #5 (**permalink**) 07-25-10, 06:11

As you have defined a foreign key constraint and you require a view, it is better you understand the concept of JOINS and Views.

To provide an appropriate solution it would be helpful if you could list the structure of the two tables, and we may be able to help you

Regards
Ashique

ninja_condom · #6 (**permalink**) 07-26-10, 10:25

Please list the Columns and datatypes of both tables individually for resolution.

Internet Services

Web Development

Digital Marketing

Consumer Tech