Results 1 to 4 of 4

Plz help me make an SQL Statement for this


This discussion is about "Plz help me make an SQL Statement for this" in the "Programming" forums.
I got two tables, Physical and Dental Physical has Description, Date, Pet_Number and Dental has the same How Do I make it so it will ...

  1. #1
    Elite Member DeathFox's Avatar
    Join Date
    Jul 2007
    Posts
    1,479

    Default Plz help me make an SQL Statement for this


    I got two tables, Physical and Dental

    Physical has Description, Date, Pet_Number and Dental has the same

    How Do I make it so it will look like this

    Physical Description | Physical Date
    Dental Description | Dental Date

    And ma.arange sile by their date. I tried to cross join pero ang mugawas kay Physical Description | Physical Date | Dental Description | Dental Date


    Plz help me make an SQL Statement for this



  2. #2
    C.I.A. dlanyer77's Avatar
    Join Date
    Sep 2006
    Gender
    Male
    Posts
    2,705

    Default Re: Plz help me make an SQL Statement for this

    union - operator returns results from both queries after eliminating duplications
    union all - operator returns results from both queries, including all duplications
    intersect - returns rows that are common to both queries
    minus - returns rows in the first query that are not present in the second query

    select description, date, per_number
    from physical
    UNION
    select description, date, per_number
    from dental

    or

    select a.description, a.date, a.per_number
    from (select description, date, per_number
    from physical
    UNION ALL
    select description, date, per_number
    from dental) a
    order by a.date

  3. #3
    Elite Member DeathFox's Avatar
    Join Date
    Jul 2007
    Posts
    1,479

    Default Re: Plz help me make an SQL Statement for this

    Thanks

  4. #4
    C.I.A. dlanyer77's Avatar
    Join Date
    Sep 2006
    Gender
    Male
    Posts
    2,705

    Default Re: Plz help me make an SQL Statement for this

    your welcome bro.

  5.    Advertisement

Similar Threads

 
  1. Help me find a nice name for my tiangge2
    By baby_jenie in forum General Discussions
    Replies: 19
    Last Post: 03-08-2009, 11:18 PM
  2. Replies: 1
    Last Post: 12-11-2007, 04:29 PM
  3. help me make a post...
    By jaeihj in forum Trends & Fashion
    Replies: 1
    Last Post: 09-12-2006, 08:16 PM
  4. Help me choose the right memory for my PC please!
    By Vishadomini in forum Computer Hardware
    Replies: 9
    Last Post: 03-28-2006, 01:29 AM
  5. Help me make SHout Box
    By Friend in forum Websites & Multimedia
    Replies: 1
    Last Post: 10-25-2005, 07:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
about us
We are the first Cebu Online Media.

iSTORYA.NET is Cebu's Biggest, Southern Philippines' Most Active, and the Philippines' Strongest Online Community!
follow us
#top