Hello guys,
I have this 5 tables:
CPU: BRAND, MODEL, ID_CPU, SOCKET, TYPE, WARRANTY, SOLD AND CHECKOUT
DISK: BRAND, MODEL, ID_DISK, STORAGE, TYPE, DIMENSIONS, WEIGHT, WARRANTY, SOLD AND CHECKOUT
DESKTOP: BRAND, MODEL, ID_DESKTOP, MOTHERBOARD, CPU, GRAPHICS, MEMORY, STORAGE, POWERSUPPLY, OS, DIMENSIONS, WEIGHT, WARRANTY, SOLD AND CHECKOUT
NOTEBOOK: BRAND, MODEL, ID_NOTEBOOK, MOTHERBOARD, CPU, GRAPHICS, MEMORY, STORAGE, POWERSUPPLY, OS, DIMENSIONS, WEIGHT, WARRANTY, SOLD AND CHECKOUT
RAM: BRAND, MODEL, ID_RAM, MEMORY, TYPE, DIMENSIONS, WEIGHT, WARRANTY, SOLD AND CHECKOUT
And I want to select all this information from all 5 tables but filtering by CHECKOUT, meaning this value is either 0 our 1 and show on checkout table.
PS: I'm using ACCESS DATABASE. It's a school project.
What I have tried:
Tryied to use the string "SELECT * FROM CPU,RAM,NOTEBOOK,DESKTOP,DISK WHERE CHECKOUT = 1"