• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

Inner join problem

 
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have two table

1. speeddemaill
2. highspeedd

speeddemail.java


Highspeedd.java



the main class


the sql output

select
speedemail0_.ID as ID7_0_,
highspeedd1_.ID as ID8_1_,
speedemail0_.ClientId as ClientId7_0_,
speedemail0_.Comments as Comments7_0_,
speedemail0_.Display as Display7_0_,
speedemail0_.GpsTime as GpsTime7_0_,
speedemail0_.Header as Header7_0_,
speedemail0_.Lat as Lat7_0_,
speedemail0_.Longi as Longi7_0_,
speedemail0_.ObjectId as ObjectId7_0_,
speedemail0_.Timestamp as Timestamp7_0_,
speedemail0_.Value as Value7_0_,
highspeedd1_.AlertType as AlertType8_1_,
highspeedd1_.ClientId as ClientId8_1_,
highspeedd1_.DisplayName as DisplayN4_8_1_,
highspeedd1_.FromTime as FromTime8_1_,
highspeedd1_.ObjectId as ObjectId8_1_,
highspeedd1_.Speed as Speed8_1_,
highspeedd1_.Status as Status8_1_,
highspeedd1_.Timestamp as Timestamp8_1_,
highspeedd1_.ToTime as ToTime8_1_
from
speedemaill speedemail0_
inner join
highspeedd highspeedd1_
on speedemail0_.ID=highspeedd1_.ObjectId
where
speedemail0_.ObjectId='18'

I need this type of sql output

select
speedemail0_.ID as ID7_0_,
highspeedd1_.ID as ID8_1_,
speedemail0_.ClientId as ClientId7_0_,
speedemail0_.Comments as Comments7_0_,
speedemail0_.Display as Display7_0_,
speedemail0_.GpsTime as GpsTime7_0_,
speedemail0_.Header as Header7_0_,
speedemail0_.Lat as Lat7_0_,
speedemail0_.Longi as Longi7_0_,
speedemail0_.ObjectId as ObjectId7_0_,
speedemail0_.Timestamp as Timestamp7_0_,
speedemail0_.Value as Value7_0_,
highspeedd1_.AlertType as AlertType8_1_,
highspeedd1_.ClientId as ClientId8_1_,
highspeedd1_.DisplayName as DisplayN4_8_1_,
highspeedd1_.FromTime as FromTime8_1_,
highspeedd1_.ObjectId as ObjectId8_1_,
highspeedd1_.Speed as Speed8_1_,
highspeedd1_.Status as Status8_1_,
highspeedd1_.Timestamp as Timestamp8_1_,
highspeedd1_.ToTime as ToTime8_1_
from
speedemaill speedemail0_
inner join
highspeedd highspeedd1_
on speedemail0_.ObjectId=highspeedd1_.ObjectId
where
speedemail0_.ObjectId='18'


please help how to do this one,

thanks in advance
 
Don't mess with me you fool! I'm cooking with gas! Here, read this tiny ad:
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
reply
    Bookmark Topic Watch Topic
  • New Topic