Breadcrumbs

[Dummy1912]

Hello,

who can help me
with this part i want

can't find anything :(

i tried:

Code: Select all

 "SELECT cash.description, categories_transactions.icon_ FROM(cash) INNER JOIN categories_transactions WHERE cash.description"

but didn't work

i want to load all data and get the icon from the other table.

thanks

[benji_19994]

Your go to guy for this would be #smashapps he is a guru with visual basics databases

[smashapps]

Well you have WHERE cash.description

you aren't specifying it's value i.e WHERE cash.description=1

Then it would select the row of data where the cash.description is equal to 1.

[Dummy1912]

hi again,

well i want just all records from the table cash
so is there any way to get all the data and get the icon_ from categories

i know if you do SELECT * you get all data
but can't be sure from this join part

[smashapps]

You can only use INNER JOIN if there are rows that match in both of the tables for example a First name column

Pretend I have two tables, im going to call one Table1 and other is Table2, Table1 will have the columns FirstName and LastName and table2 will have FirstName PhoneNumber

SELECT table1.FirstName, table1.LastName, table2.FirstName, table2.PhoneNumber FROM table1 INNER JOIN table2 ON table1.FirstName=table2.FirstName

Hopefully that should work otherwise just look up "SQL INNER JOIN"

[Dummy1912]

haha thanks #smashapps
it works

+rep

:( sorry can't +rep its not allowed :(