SQL Query No Data Appear RSS

• • Reply
  

  afastars

  Member

  52 Points

  221 Posts

  SQL Query No Data Appear

  Feb 01, 2013 07:35 AM|LINK

  hai all expertise

  just now i'm creating new database , what happen is that what i make a query then there are no data appear i need help regading this matters, i'm new in this.

  below is my table field

  SELECT TOP 1000 [IdKenderaan]
        ,[IdKakitangan]
        ,[NoKenderaan]
        ,[JenisKenderaan]
        ,[WarnaKenderaan]
        ,[Selenggara]
        ,[TarikhSelenggara]
        ,[TarikhSelengeraNext]
    FROM [BookingSystem].[dbo].[MaklumatKenderaan]

  SELECT TOP 1000 [IdPerjalanan]
        ,[IdKakitangan]
        ,[IdKenderaan]
        ,[TujuanPerjalanan]
        ,[TarikhGuna]
        ,[TarikhTamat]
        ,[MasaGuna]
        ,[MasaTamat]
        ,[Destinasi]
        ,[JumlahPenumpang]
    FROM [BookingSystem].[dbo].[MaklumatPerjalanan]

  below this is my query

  SELECT     MaklumatKenderaan.NoKenderaan, MaklumatKenderaan.JenisKenderaan, MaklumatPerjalanan.TujuanPerjalanan, MaklumatPerjalanan.TarikhGuna,
                        MaklumatPerjalanan.TarikhTamat, MaklumatPerjalanan.MasaGuna, MaklumatPerjalanan.MasaTamat, MaklumatPerjalanan.Destinasi,
                        MaklumatPerjalanan.JumlahPenumpang
  FROM         MaklumatKenderaan INNER JOIN
                        MaklumatPerjalanan ON MaklumatKenderaan.IdKenderaan = MaklumatPerjalanan.IdKenderaan

• • Reply
  

  dhol.gaurav

  Contributor

  3998 Points

  725 Posts

  Re: SQL Query No Data Appear

  Feb 01, 2013 08:44 AM|LINK

  your query is look ok, you need to verify the data

  weather  value of "[IdKenderaan]" in "[MaklumatKenderaan]" is availabe in "[IdKenderaan]" of table [MaklumatPerjalanan]

  your query only returns thoes record which have common "[IdKenderaan]" value

  let me know if any query

  Thanks,
  Gaurav Dhol
  Skype ID : dhol.gaurav
  If My Post contains helped you, Please Mark as Answer
  • Edited by afastars on Feb 06, 2013 02:19 PM
  • Edited by decker dong - msft on Feb 07, 2013 01:10 AM
  • Marked as answer by decker dong - msft on Feb 07, 2013 01:10 AM
• • Reply
  

  NadeemZee

  Participant

  942 Points

  178 Posts

  Re: SQL Query No Data Appear

  Feb 01, 2013 08:55 AM|LINK

  If you want to return query which is in left table whether right table is blank then use Left outer join in place of Inner Join

  If you want to return query which is in right table whether left table is blank then use Right outer join in place of Inner Join

  like

  SELECT     MaklumatKenderaan.NoKenderaan, MaklumatKenderaan.JenisKenderaan, MaklumatPerjalanan.TujuanPerjalanan, MaklumatPerjalanan.TarikhGuna,
                        MaklumatPerjalanan.TarikhTamat, MaklumatPerjalanan.MasaGuna, MaklumatPerjalanan.MasaTamat, MaklumatPerjalanan.Destinasi,
                        MaklumatPerjalanan.JumlahPenumpang
  FROM         MaklumatKenderaan LEFT OUTER JOIN
                        MaklumatPerjalanan ON MaklumatKenderaan.IdKenderaan = MaklumatPerjalanan.IdKenderaan

  OR

  SELECT     MaklumatKenderaan.NoKenderaan, MaklumatKenderaan.JenisKenderaan, MaklumatPerjalanan.TujuanPerjalanan, MaklumatPerjalanan.TarikhGuna, 
                        MaklumatPerjalanan.TarikhTamat, MaklumatPerjalanan.MasaGuna, MaklumatPerjalanan.MasaTamat, MaklumatPerjalanan.Destinasi, 
                        MaklumatPerjalanan.JumlahPenumpang
  FROM         MaklumatKenderaan RIGHT OUTER JOIN
                        MaklumatPerjalanan ON MaklumatKenderaan.IdKenderaan = MaklumatPerjalanan.IdKenderaan

  
  
  YOUR QUERY WILL return those records which are common in both tables else not returning any row.

  Good Luck
  Do FEAR (Face Everything And Rise)
  Please mark as Answer if my post helps you..!
  
  
  • Edited by afastars on Feb 06, 2013 02:19 PM
  • Edited by decker dong - msft on Feb 07, 2013 01:10 AM
  • Marked as answer by decker dong - msft on Feb 07, 2013 01:10 AM
• • Reply
  

  afastars

  Member

  52 Points

  221 Posts

  Re: SQL Query No Data Appear

  Feb 06, 2013 02:22 PM|LINK

  hi dhol.gaurav and NadeemZee

  dhol.gaurav resolve my problem,

  NadeemZee give me some knowledge that i never notice before this...thank's a lot's to both of you expertise

  after this there are lot's of query maybe i need guidance from expertise here..:))