Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Count related records

2 Posts 2 Posters 0 Views 1 Watching

S Offline
S Offline
Soleil couchant

wrote on last edited by

#1

Hi there, I have a stock table and a barcode table. A stock can have many barcode records and a barcode belongs to only one stock. How can I query the database, so as it returns me those stock which have more than one barcode? Thanks for helping, David
A 1 Reply Last reply

0
S Soleil couchant

Hi there, I have a stock table and a barcode table. A stock can have many barcode records and a barcode belongs to only one stock. How can I query the database, so as it returns me those stock which have more than one barcode? Thanks for helping, David
A Offline
A Offline
andyharman

wrote on last edited by

#2

select StockCode, count(*) BarcodeCount from BarCode group by StockCode having count(*) > 1
1 Reply Last reply

0

Log in to reply