Migrate from MS Access to Bubble

[carloslealdeoliveira]

Hi, I’m having troubble doing this on bubble. It’s supposed to display the recipy for making 2 different products, one with 4 and the other with 5 different ingredients. It works fine on MS Access . . can anyone help me?

SELECT Vendas.IdVenda, DetalhesDeTipo.IdTipo, Tipologia.Tipo, DetalhesDeTipo.Quantidade, Produtos.Produto, Produção.Quantidade, Produção.Largura, Produção.Altura
FROM Vendas INNER JOIN ((Tipologia INNER JOIN (Produtos INNER JOIN DetalhesDeTipo ON Produtos.IdProduto = DetalhesDeTipo.IdProduto) ON Tipologia.IdTipo = DetalhesDeTipo.IdTipo) INNER JOIN Produção ON Tipologia.IdTipo = Produção.IdTipo) ON Vendas.IdVenda = Produção.IdVenda
WHERE (((Vendas.IdVenda)=1230));

Shoul look like this:

[carloslealdeoliveira]

Maybe intersect with in place of INNER JOIN ???

[lindsay_knowcode]

Figuring out how to structure your Bubble DB coming from a SQL and Relationship DB world is something most people have to deal with in the early days. Look for posts by this guy @cmarchan - he helpfully often posts a collection of tutorials links. Long story short “inner joins” in Bubble is equivalent to “putting a Thing on another Thing” (yes Bubble calls them Things )

[cmarchan]

@carloslealdeoliveira

The below post by @NigelG may help understand the “Bubblish” way when thinking in sql terms

Thanks for the kind mention @lindsay_knowcode

SQL Joins Vs Bubble

Thought this might help, if you aren’t coming from an SQL background then it will probably confuse! Two Tables, not linked (we can do that another day). Let’s not think about duplicate values either. Table A Name Parrot, Banana, Monkey, Apple Table B Name Ruby, Banana, Diamond, Apple INNER JOIN SELECT * FROM TableA INNER JOIN TableB ON TableA.name = TableB.name [image] In Bubble this is achieved via an INTERSECT of two searches. [image] [image]

[carloslealdeoliveira]

Thanks Lindsay . . . I’ll check it out