except codeigniter

By
Buscando una manera de conseguir un INNER JOIN TABLE2 ON TABLE1.ID!=TABLE2.ID, encontre que eso no era posible, entonces segui buscando y encontre EXCEPT, pero solo funciona para sql server y oracle creo, pero para mysql no, asi que buscando encontre esto:

$consulta='select table1.* from table1
where not exists (
select table2.idt1
from table2 where table1.idt1=table2.idt1
)'


me funciono, no lo encontre en codeigniter, asi que lo puse como:

$this->db->query($consulta);

recien me entero de esto, seguire posteando lo que aprendo.

Comments

Post a Comment

Popular posts from this blog

Difference between software engineering and computer science

By
Image
Computer Science vs. Software Engineering: What’s the Real Difference? It’s a classic debate in the tech world. While both majors involve staring at code for hours, they approach the digital world from very different angles. If you’re struggling to decide between the two, here is a breakdown of how they actually function in the real world. 1. Computer Science (The "Why") Computer Science (CS) is rooted in mathematics and logic . It’s less about building a specific app and more about understanding the architecture of computation itself. Focus: Discrete mathematics, data structures, and computational theory. The Goal: To find the most efficient way to solve a problem. For example, a CS major might use Big O Notation to calculate the efficiency of an algorithm: O(n log n) . Career Paths: AI Researcher, Data Scientist, Systems Architect. 2. Software Engineering (The "How") Software Engineering (SE) is a branch of engineering . It applies structured principles to the ...
Read more

Basketball in Peru

By
Image
The basketball in Peru is growing, thanks to the globalization, this beautiful sport is getting more fans and a lot of young players. History In the 70´s and early 80's the peruvian basketball was at his peak, they won some southamerica championships, and played at the FIBA world cup. In the 90's until 2022, basketball had many problems, the worst was the disaffiliation of FIBA in 2021. Nowadays In 2023 the national basketball federation was reborn. They organized the u17 national championship, the national league which is the most ranked competition in Peru. And they are on their way to get their affiliation to FIBA again. There is still no professional league but They are in progress. So far the best leagues are "Liga de Basketball de Lima" and "Liga de Basketball de Arequipa". To summarize, Peru is a growing basketball nation, they need a lot of support to get a better basketball environment. All the help is welcomed. If you want to know more about peruvi...
Read more

How to stop procrastination as a remote developer

By
    Procrastination is one of the biggest challenges for remote developers.  The comfort of home and being around family can sometimes lead you to focus on things that aren’t related to your job. Before you know it, the day is nearly over, and you’re left feeling unproductive and frustrated. If you’re struggling with this, here are a few key tips that I recommend to help combat procrastination. Let’s dive in! 1. Identify What Makes You Procrastinate The first step is figuring out what’s actually distracting you. These distractions can be small or big, and sometimes you might not even realize they’re there—they just blend into the background. Identifying them is crucial if you want to avoid them. Advice : Use an app tracker on your laptop and phone to see exactly where your time is going. This helps make those invisible distractions visible. 2. Create a Dedicated Workspace When you’re working from home, shared spaces can easily become sources of distraction. It’s important...
Read more