Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Ok this is what I need to do
I have a payments table where I want to select a payment date range and select for a specific judgecode. The judge code could come from up to 5 different tables here are the table sturctures and some values
payments
py_paydate py_module pkeyident
'01/01/2005' 'MV' '1'
'02/01/2005' 'SC' '2'
'04/01/2005' 'CRM' '3'
'04/01/2005' 'LL' '4'
'01/01/2005' 'CV' '5'
MV
keyident mv_judge
'1' 'MMM'
SC
keyident sc_judge
'2' 'LLL'
LL
keyident ll_judge
'4' 'LLL'
CRM
keyident crm_judge
'3' 'AAA'
CV
keyident sc_judge
'5' 'LLL'
where py_module determines which module the payment came from
so in my select statement I want to select all payments
from 01/01/2005 - 12/31/2005 with judge code ='LLL'
Hope this helps explain what I am trying to do a little better !
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement