Dutpethyexpit
New Member
\[quote\] Possible Duplicate:
SQL AND operator not working properly \[/quote\]I have following two tablesLandParcels Table\[code\]Blockid ParcelNo storPri ======= ======== ======= 52000105 3 State 52000105 4 Private 52000105 5 State52000401 12 State52001002 23 State\[/code\]Actions Table\[code\]Blockid ParcelNo ActionTaken ======= ======== ===========52000105 3 Received 52000105 3 Send to Computer 52000105 4 Received 52000105 5 Received52000401 12 Received 52001002 23 Received \[/code\]I want to filter selected blockid (eg: 52000105) and records not "Sent to Computer"acc. to two tableseg. I want to filter the records from landparcels where blockid 52000105 and not sent to Computer ("Received" only)I want the result like this (Selected Block is 52000105)\[code\]Blockid ParcelNo ActionTaken ======= ======== ===========52000105 4 Received 52000105 5 Received\[/code\]
SQL AND operator not working properly \[/quote\]I have following two tablesLandParcels Table\[code\]Blockid ParcelNo storPri ======= ======== ======= 52000105 3 State 52000105 4 Private 52000105 5 State52000401 12 State52001002 23 State\[/code\]Actions Table\[code\]Blockid ParcelNo ActionTaken ======= ======== ===========52000105 3 Received 52000105 3 Send to Computer 52000105 4 Received 52000105 5 Received52000401 12 Received 52001002 23 Received \[/code\]I want to filter selected blockid (eg: 52000105) and records not "Sent to Computer"acc. to two tableseg. I want to filter the records from landparcels where blockid 52000105 and not sent to Computer ("Received" only)I want the result like this (Selected Block is 52000105)\[code\]Blockid ParcelNo ActionTaken ======= ======== ===========52000105 4 Received 52000105 5 Received\[/code\]