Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2010
    Posts
    1

    Unanswered: need help with some Simple queries :(

    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

  2. #2
    Join Date
    Jul 2010
    Posts
    5
    Please list out the names and data types of each of the columns in both tables.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Thumbs down Study

    Quote Originally Posted by suhas_sm View Post
    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.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Mar 2009
    Location
    Afghanistan
    Posts
    1
    Please list the Columns + datatypes of both tables individually to resolve.

  5. #5
    Join Date
    Jul 2010
    Posts
    3
    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

  6. #6
    Join Date
    Jul 2010
    Location
    Kim Jong IL's Palace
    Posts
    2
    Please list the Columns and datatypes of both tables individually for resolution.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •