Member Avatar for dennysimon

Hi all

I have 2 tables TblHP and TblDP
how is the query to select price on certain TblGood_Kode which is before certain date
tia
denny

TblHP

No_Inv
Date
TblCustomer_Kode (as foreign key to TblCustomer)
//---------------

TblDP

TblHP_No_Inv (as foreign key to TblHP)
price
TblGood_Kode (as foreign key to TblGood)

  • 2 Contributors
  • 1 Reply
  • 55 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

Kindly post what have you tried so far from your side and also post the proper table structure for analysis.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.